from django.db import models

# Create your models here.


class ATOP_CD_OPERATION_USER(models.Model):
    """高危操作权限表"""
    user_module = models.IntegerField(unique=False, null=False)
    org_id = models.CharField(max_length=64, unique=False, null=False)
    relate_id = models.CharField(max_length=64, unique=False, null=False)
    operation = models.CharField(max_length=64, unique=False, null=False)
    create_by = models.CharField(max_length=32, unique=False, null=False)
    create_time = models.DateTimeField(unique=False, null=False, auto_now_add=True)

    class Meta:
        db_table = 'ATOP_CD_OPERATION_USER'


class HighriskField(models.Model):
    """高危字段信息"""
    highrisk_field = models.CharField(db_column='HIGHRISK_FIELD', max_length=64, blank=True, null=True)  # Field name made lowercase.
    creator = models.CharField(db_column='CREATOR', max_length=32, blank=True, null=True)  # Field name made lowercase.
    create_time = models.DateTimeField(db_column='CREATE_TIME', blank=True, null=True)  # Field name made lowercase.
    update_time = models.DateTimeField(db_column='UPDATE_TIME', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        db_table = 'highrisk_field'


class TSrOSms(models.Model):
    """短信上行"""
    tenant_id = models.CharField(db_column='TENANT_ID', max_length=20, blank=True, null=True)  # Field name made lowercase.
    peovince_code = models.CharField(db_column='PEOVINCE_CODE', max_length=4, blank=True, null=True)  # Field name made lowercase.
    sms_id = models.IntegerField(db_column='SMS_ID', blank=True, null=True)  # Field name made lowercase.
    force_object = models.CharField(db_column='FORCE_OBJECT', max_length=50, blank=True, null=True)  # Field name made lowercase.
    send_time_code = models.CharField(db_column='SEND_TIME_CODE', max_length=10, blank=True, null=True)  # Field name made lowercase.
    send_count_code = models.IntegerField(db_column='SEND_COUNT_CODE', blank=True, null=True)  # Field name made lowercase.
    recv_object = models.CharField(db_column='RECV_OBJECT', max_length=50, blank=True, null=True)  # Field name made lowercase.
    sms_is_up_mode = models.CharField(db_column='SMS_IS_UP_MODE', max_length=1, blank=True, null=True)  # Field name made lowercase.
    sms_type_code = models.CharField(db_column='SMS_TYPE_CODE', max_length=5, blank=True, null=True)  # Field name made lowercase.
    sms_content = models.CharField(db_column='SMS_CONTENT', max_length=1024, blank=True, null=True)  # Field name made lowercase.
    sms_reply_content = models.CharField(db_column='SMS_REPLY_CONTENT', max_length=1024, blank=True, null=True)  # Field name made lowercase.
    force_time = models.DateTimeField(db_column='FORCE_TIME', blank=True, null=True)  # Field name made lowercase.
    smspriority = models.IntegerField(db_column='SMSPRIORITY', blank=True, null=True)  # Field name made lowercase.
    sd_flag = models.IntegerField(db_column='SD_FLAG', blank=True, null=True)  # Field name made lowercase.
    alrdy_atmp_tms_cnt = models.SmallIntegerField(db_column='ALRDY_ATMP_TMS_CNT', blank=True, null=True)  # Field name made lowercase.
    crt_time = models.DateTimeField(db_column='CRT_TIME', blank=True, null=True)  # Field name made lowercase.
    refer_staff_id = models.CharField(db_column='REFER_STAFF_ID', max_length=50, blank=True, null=True)  # Field name made lowercase.
    refer_org_id = models.CharField(db_column='REFER_ORG_ID', max_length=50, blank=True, null=True)  # Field name made lowercase.
    update_time = models.DateTimeField(db_column='UPDATE_TIME', blank=True, null=True)  # Field name made lowercase.
    sms_fdbk_satis_state = models.CharField(db_column='SMS_FDBK_SATIS_STATE', max_length=5, blank=True, null=True)  # Field name made lowercase.
    task_id = models.IntegerField(db_column='TASK_ID', blank=True, null=True)  # Field name made lowercase.
    srv_reqst_id = models.BigIntegerField(db_column='SRV_REQST_ID', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        db_table = 't_sr_o_sms'


class TSrOSmsH(models.Model):
    """短信下行"""
    tenant_id = models.CharField(db_column='TENANT_ID', max_length=20, blank=True, null=True)  # Field name made lowercase.
    peovince_code = models.CharField(db_column='PEOVINCE_CODE', max_length=4, blank=True, null=True)  # Field name made lowercase.
    sms_id = models.IntegerField(db_column='SMS_ID', blank=True, null=True)  # Field name made lowercase.
    force_object = models.CharField(db_column='FORCE_OBJECT', max_length=50, blank=True, null=True)  # Field name made lowercase.
    send_time_code = models.CharField(db_column='SEND_TIME_CODE', max_length=10, blank=True, null=True)  # Field name made lowercase.
    send_count_code = models.IntegerField(db_column='SEND_COUNT_CODE', blank=True, null=True)  # Field name made lowercase.
    recv_object = models.CharField(db_column='RECV_OBJECT', max_length=50, blank=True, null=True)  # Field name made lowercase.
    sms_is_up_mode = models.CharField(db_column='SMS_IS_UP_MODE', max_length=1, blank=True, null=True)  # Field name made lowercase.
    sms_type_code = models.CharField(db_column='SMS_TYPE_CODE', max_length=5, blank=True, null=True)  # Field name made lowercase.
    sms_content = models.CharField(db_column='SMS_CONTENT', max_length=1024, blank=True, null=True)  # Field name made lowercase.
    sms_reply_content = models.CharField(db_column='SMS_REPLY_CONTENT', max_length=1024, blank=True, null=True)  # Field name made lowercase.
    force_time = models.DateTimeField(db_column='FORCE_TIME', blank=True, null=True)  # Field name made lowercase.
    smspriority = models.IntegerField(db_column='SMSPRIORITY', blank=True, null=True)  # Field name made lowercase.
    sd_flag = models.IntegerField(db_column='SD_FLAG', blank=True, null=True)  # Field name made lowercase.
    alrdy_atmp_tms_cnt = models.SmallIntegerField(db_column='ALRDY_ATMP_TMS_CNT', blank=True, null=True)  # Field name made lowercase.
    crt_time = models.DateTimeField(db_column='CRT_TIME', blank=True, null=True)  # Field name made lowercase.
    refer_staff_id = models.CharField(db_column='REFER_STAFF_ID', max_length=50, blank=True, null=True)  # Field name made lowercase.
    refer_org_id = models.CharField(db_column='REFER_ORG_ID', max_length=50, blank=True, null=True)  # Field name made lowercase.
    update_time = models.DateTimeField(db_column='UPDATE_TIME', blank=True, null=True)  # Field name made lowercase.
    sms_fdbk_satis_state = models.CharField(db_column='SMS_FDBK_SATIS_STATE', max_length=5, blank=True, null=True)  # Field name made lowercase.
    task_id = models.IntegerField(db_column='TASK_ID', blank=True, null=True)  # Field name made lowercase.
    srv_reqst_id = models.BigIntegerField(db_column='SRV_REQST_ID', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        db_table = 't_sr_o_sms_h'